how we load the data from source to staging area
- 4 Answers
- 7485 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manik
By using one to one mapping we can load data into staging area like how we will load Flat file data into staging relational table.
| Is This Answer Correct ? | 0 Yes | 0 No |
replace multiple spaces with single space.
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
can we have to do changes in session property when we are dynamically generating target files?
what is sql override?what is the use of it?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
can we create index and drop index in exsisting table while using infomatica
what type of transformation is not supported by mapplets?
What is the difference between a table and the materialized view?
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
in which situations do u go for starflake schema ?
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
Teradata 
