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 flow
4 12017i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
3 11437what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
2 6635for 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 22288Post New Informatica Questions
What is an aggregator transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Explain what is informatica metadata and where is it stored?
What is informatica etl tool?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Can we get 1st record through Informatica(without sequence number).
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Difference between Data and Index Caches?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What the difference is between a database, a data warehouse and a data mart?
Name the different lookup cache(s)?
Differentiate between a repository server and a powerhouse?
Differentiate between reusable transformation and mapplet.
Describe data concatenation?