Interested to Buy Any Domain ? << Click Here >> for more details...
following scenario i have 1000 record flatfile source i
want ist row to ist target 2nd eow to 2nd target 3rd row to
3rd target how will u do?
- 7 Answers
- 10606 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / rakesh
use a Sequence Generator to generate a column NUM
in Router 1st Group: MOD(NUM,3)=1
2nd Group: MOD(NUM,3)=2
3rd Group: MOD(NUM,3)=0
Im not sure about MOD format, but this idea will workout..
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
How do you use reject loader.
What you know about transaction control transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is the size of u r source(like file or table)?
What are the issues you have faced in your project? How did you overcome those issues?
Explain the difference between a data warehouse and a data mart?
State the differences between sql override and lookup override?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Explain informatica architecture - version 8 / 9
How can we use batches?
What are the new features of informatica 9.x developer?
What is a sequence generator transformation?
What is persistent lookup cache?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
