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
- 12325 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
Explain why we use partitioning the session in informatica?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain lookup transformation source types in informatica
How can a transformation be made reusable?
What are the advantages of using informatica as an etl tool over teradata?
What do you mean by blocking transformation?
How does the aggregator transformation handle null values?
What is a snowflake schema?
What is the use of code page?
What is meant by target load plan?
What are the main issues while working with flat files as source and as targets ?
Repository user profiles
Explain the features of connected and unconnected lookup.
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
