Can you use the maping parameters or variables created in
one maping into any other reusable transformation?
Answer / swetha
Yes.Because reusable tranformation is not contained with any
maplet or maping.
| Is This Answer Correct ? | 2 Yes | 0 No |
What are the ETL tools available in DWH?
How do you join more than 3 flat files in informatica?
how do u fnd the duplicate rows and how to delete the duplicate rows?
Without source how to insert record to target?
What are the components of workflow manager?
What are the tasks that source qualifier performs?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is tracing level and what are the types of tracing level?
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
What is data caches/ index caches?
How can we eliminate duplicate rows from flatfile,explain?