Interested to Buy Any Domain ? << Click Here >> for more details...
we have 6 records in source , i need 2nd record in one
target and 5th record in one target or 2nd & 5th record in
same target.
- 8 Answers
- 12231 Views
- I also Faced
- E-Mail Answers
Answer Posted / sateesh
Source-->SQ-->SequenceGenerator-->Exp-->Rtr-->Target
In Exp Transformation assign a variable port like v_num=10;
In Rtr Transformation use defined group give a condition
like
IIF(curvar>1,IIF(Mod(v_num,curvar)=0,0,1),1)
Please correct me if am wrong.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is Data Caches size?
Explain the different dimensions.
Explain what is informatica metadata and where is it stored?
Explain the difference between mapping parameter and mapping variable?
what are the deliverables?in your project?
What is pmcmd command?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the issues you have faced in your project? How did you overcome those issues?
Can we create two repositories on same database instance in oracle?
How to handle decimal places while importing a flatfile into informatica?
How we can create indexes after completing the load process?
What is the scenario which compels informatica server to reject files?
What do mean by local and global repository?
write a query to retrieve the latest records from the table sorted by version(scd)
Target increases every day even though no new record was inserted
