i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow4 8919
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow3 8371
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?2 4857
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.11 15055
how u know when to use a static cache and dynamic cache in lookup transformation.9 20172
explain different types of modeling.2 9157
what is shared Cache. when we will use shared Cache?4 17457
Which kind of index is preferred in DWH?3 9188
what is fact table?9 8719
what is dimension table?17 24074
What is complex mapping?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are the different clients of powercenter?
Design time, run time. If you don't create parameter what will happen
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is the maplet?
How many numbers of sessions can one group in batches?
Write the unconnected lookup syntax and how to return more than one column.
How would you copy the content of one repository to another repository?
What are the tasks that can be performed using sq?
4 yrs etl devloper roles and responsibilities?any body give solutions
Where is metadata stored?
What is enterprise data warehousing?
What are pre and post-session shell commands?
What are the different lookup cache(s)?