Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / baiju
When a row enters a transformation, informatica assigns a
rownumber. if this number change for a row, that's an
Active transformation. In other words the nth row comming
IN will go as n'th row, then the transformation is PASSIVE.
Sorter is an active transformation!! IT never changes
the total row count, it changes only the order!!
| Is This Answer Correct ? | 15 Yes | 19 No |
Post New Answer View All Answers
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
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
What are the types of schemas we have in data warehouse.
How to load data in informatica ?
How do you update the records with or without using update strategy?
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 confirmed fact in dataware housing?
Write the unconnected lookup syntax?
What are the different types of olap? Give an example?
How might one distinguish in the case of mapping is right or not without associating session?
How to delete duplicate row using informatica?
how tokens will generate?
How to partition the Session?
What are junk dimensions?
what is $$$$?
