Interested to Buy Any Domain ? << Click Here >> for more details...
I HAVE 10 records in source. I want to store i record in
target 1, second record in target 2, third record in target
3, 4 th record again in target 11, 5th again in target 2,
6th again in target3 etc.... how it is possible?
- 5 Answers
- 11260 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / manthiramoorthy. g
S-SQ-EXP-SEQ-RTR-Tgt1,Tgt2,Tgt3
In Router: (Group Condition)
MOD(nextval,3)=0 Connect To Tgt1
MOD(nextval,3)=1 Connect To Tgt2
MOD(nextval,3)=2 Connect To Tgt3
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How do you load first and last records into target table?
Which version configuration tool used in ur project?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Where do we use mapping variables in informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Describe the impact of several join conditions and join order in a joiner transformation?
How do you load unique records into one target table and duplicate records into a different target table?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Partition, what happens if the specified key range is shorter and longer
What is powercenter on grid?
Different qualification between a related rotate toward the sky and isolates look upward?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
Explain about cumulative Sum or moving sum?
