i have to extract data from a flat file.the flat file has 10
records.i have to extract the 1st and 5th record every
time.how is it done.
Answer Posted / koti
take sequence generator to target and take expr
transformation to source qualifiew transf. and one new
port. and define that port as iif(sno=1 or 5,'true','false')
connect these to target.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Explain what are the different versions of informatica?
Why filter transformation is an active one?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Is there any target staging area in informatica not staging area
What is mapping debugger?
Define the various join types of joiner transformation?
What is joiner transformation in informatica?
Differentiate between a repository server and a powerhouse?
Explain lookup transformation in informatica
What do you mean by channel change?
Do you find any difficulty while working with flat files as source and target?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How do you remove duplicate records in informatica? And how many ways are there to do it?
Is it possible to define a single node as a Gateway node as well as worker node?