Interested to Buy Any Domain ? << Click Here >> for more details...
My i/p is 1,2,3,4,5,6,7,8,9,10………..
o/p to be populate in two tables as below.
o/p1: 10,20,30,40,50,60,70,80,90…….
o/p2: 11,21,31,41,51,61,71,881,91…….
- 7 Answers
- 9828 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / sufi
Use router with two groups with the below conditions:
Group1 condition : Mod( Col, 10) = 0
Group2 condition : Mod ( Col, 10) = 1
Group1 will allow data like 10,20,30,40....
Group2 will allow data like 11,21,31,41....
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to generate sequence numbers without using the sequence generator transformation?
How will the document be delivered to me?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
How can we improve session performance in aggregator transformation?
Can we get 1st record through Informatica(without sequence number).
can we override a native sql query within informatica? How do we do it?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
wat are deployement groups in informatica, how it will be used for developers
Have you worked with/created Parameter file
Explain what is informatica metadata and where is it stored?
What is the difference between router and filter?
How can we create index after completion of load process?
What does refresh system mean, and what are its distinctive choice?
What is blocking transformation?
Name the different lookup cache(s)?
