how can import the data from the flat files?
Answers were Sorted based on User's Feedback
Answer / immu
Source Analyzer---->click on import from file---->select file
| Is This Answer Correct ? | 1 Yes | 0 No |
explain about unit testing? in real time?
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
What are Business Components in Informatica?
What are the types of lookup transformation?
What is the difference between warehouse key and surrogate key?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
In any project how many mappings they will use(minimum)?
how to return multiple columes through through un-connect lookup?
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
Which transformation should u need while using the cobol sources as source defintions?
As union transformation gives UNION ALL output, how you will get the UNION output?