How to load relational source into file target?

Answer Posted / kammari.krishnaiah

load the data form source system to target in two ways.
one is directly storing another one is mapping (etl)in
infirmatia

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the different kinds of facts.

560


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1682


What are the restrictions of union transformation?

574


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

619


How many input parameters can exist in an unconnected lookup?

987






What is the fact table?

584


What is informatica worklet?

608


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1004


can you please explain me pre session and post session options?

6366


What is the difference between source qualifier transformations source filter to filter transformation?

576


Can you use flat files in Mapplets.

2215


What is the advantage of informatica?

644


Explain the difference between mapping parameter and mapping variable?

600


How do you load alternate records into different tables through mapping flow?

1287


What are the types of schemas we have in data warehouse and what are the difference between them?

517