If one flat file contains n number of records., we have to
load the records in target from 51 to 100.. how to use
expressions in Informatica..?
Answer Posted / reena
use sequence generator to get row no. for each record ,then
use filter giving the condition (row no.greater than 50 and
less than 100)
Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Define joiner transformation?
What is the use of transformation?
What is mapping debugger?
differences between service based and product based?
what is the -ve test case in your project.
What is data movement mode in Informatica and difference between them?
can we override a native sql query within informatica? How do we do it?
What are multi-group transformations?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is sq transformation?
Explain the mapping variable usage example in informatica
What is substr in informatica?
What are the new features of informatica 9.x in developer level?