DSXchange

Hi folks

In filter we have an option like "output row only once" what's the functionality of this option can anyone explain with example



Thanks

Hi ray

Actually i'm at beginner level .....i think we cannot connect multiple sources to transformer in that case how come your logic works.




Thanks

Hi chullet
From the files you can see that S1 has sno's and S2 won't.Those are flat-files and i want to combine them in a serial fashion.

Hi Andrw

It's not like that see

S1
sno,deptno
1,10
2,10
3,20
4,30

and

S2
deptno
10
40
50

now i need output like

S-out
sid,deptno
1,10
2,10
3,20
4,30
5,10
6,40
7,50

Hi Folks

i have scenario in which two sources are the assume s1,s2 for s1 i have sno column but where as s2 sno is not there but i have to combine both those records and sno should continue from s1 to s2.



Thanks

Hi ray

I'm not a premium member so i'm not able to see your solution completely.





Thanks

Hi all

i'm getting an error like below


Failed to connect to information server engine:My project name

username and password are incorrect.If credential mapping is used please check username and password matches correctly.

please help me out of this problem.



Regards,
Prince_Hyd

Hi

can you explain in detail please.



Thanks

Hi Folks

i have an input like this

Num

74584578845
73432848874
40594589485

i want to place '-' after third position.So output should be like

Num

745-84578845
734-32848874
405-94589485


Thanks

Hi Siva

perfect solution




Thanks

Hi folks

I have a source file like this

name
hyundai
suzuki
ford
honda

i want to make first and last letter capital how can i perform this.


Thanks

Hi ray

finished.Interviewer asked me that scenario and i din't got how to solve that.

Hi Folks

I have a source like this

Empno,Ename,MGR
101,Tarun,vinay
102,vinay,Anand

i need output like this

Empno,Ename,MGR
101,Tarun,vinay,Anand
102,Vinay,Anand,Anand

using Transformer how to solve this.


Thanks

Hi ray

can you be clear with your solution where can i find KeyChange function in transformer.Please clearly explain the solution.




Thanks

Hi Do like this SEQ----------TRN------------ Target 1 Target2 Target 3 1)in Transformer keep the logic in (constraint : Index(country,'India',1) for Target1 and in that constraint itself you will find otherwise checkbox tick it so that the record which wont match that condition will move to the Targ...