Answer Posted / nagarjuna redd
Use to Lookup a data of table,view and synonym from a
relational or flat files. U can use multiple lookup
transformations in mapping.
- Used to get a related value
- used to perform a calculation
- mainly used in slowly changing dimension
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
explain abt ur project architecture?
What are the different options available for update strategy?
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.
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What if the source is a flat-file?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
permutations of mapplet
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Differentiate between a repository server and a powerhouse?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Where is metadata stored?
What are the mapping parameters and mapping variables?
What is a stored procedure transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?