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
explain about unit testing? in real time?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How do you load only null records into target? Explain through mapping flow.
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
tell me the rules and responsblites in our project(my project is development)
What is the sequence generator transformation in informatica?
What are Dimensional table?
What is native users?
what is the hint? how to use it to reduce the query processing in program?
What is flashback table ? Advance thanks
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
how to create user defined function (udf) in informatica
Scheduling properties,whats the default (sequential)
How to partition the Session?