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
What all are steps in up gradation of Informatica server?
What are connected or unconnected transformations?
What is an Integration service in Informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Can we change Dynamic to Static or Persistent cache? If so what happens?
What do you mean by blocking transformation?
Why do we need informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is meant by active and passive transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What are the different ways to implement parallel processing in informatica?
What are the various types of transformation?
Explain incremental aggregation in informatica
what is diff b/t sorter t/r and agg have the option sorter property...