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
- 11950 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
I have a flat file, want to reverse the contents of the flat file
What are the different versions of informatica?
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
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
can u any challenge your project?
Explain the features of connected and unconnected lookup.
What is rank transform?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Where are the source flat files kept before running the session?
Scheduling properties,whats the default (sequential)
my source is junk data how will u remove that junk data by using unix please any one replay me
How can you define user defied event?
How is union transformation utilized?
What is dimensional table?
How do you remove duplicate records in informatica? And how many ways are there to do it?
