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
- 11627 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / rucha
i will use a sequence generator to get the row number then
input this sequence numbers to an expression transformation
where i will give an if condition (row number mod 3) then
the result be stored in a variable port say x.this variable
port value is filtered using router transformation as rows
with x=1 in group1,x=2 in group 2 and x=3 in default. the
resultant groups are connected to the targets 1,2 and 3
respectively
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
How can we use batches?
What is the difference between a connected look up and unconnected lookup?
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?
Explain sql transformation in script mode examples in informatica
pmscmd startworkflow -sv
Which transformation should we use to normalise the COBOL and relational sources?
How to create or import flat file definition in to the warehouse designer?
How to do unit testing in informatica? How to load data in informatica ?
explain one complex mapping with logic? sales project?
What is the difference between Active and Passive transformation?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What are the advantages of using informatica as an etl tool over teradata?
what are the Methods For Creating Reusable Transformations?
Explain the tuning lookup transformation - informatica
How to extract sap data using informatica?
