i having mapping
emp---> sq_emp--->target
using this mapping i have to load dept table values into
target... (condition assume there is no primary and foreign
key relation between emp(table x) and dept (table Y))
- 5 Answers
- 9141 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / ahalya inturi..
interviewer asked the this question.. i too felt that its not possible to load into target without helping primary key foreign key relation ship.. but i am looking forward for more answers.. plz if any body can...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the Process to creating lookup transformation in informatica
What is the difference between router and filter?
Informatica settings are available in which file?
Explain the features of connected and unconnected lookup.
Write the unconnected lookup syntax and how to return more than one column.
Can you use flat files in Mapplets.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Design a mapping to load a target table with the following values from the above source?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How many ways a relational source definition can be updated and what are they?
my source is junk data how will u remove that junk data by using unix please any one replay me
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is domain in terms of informatica?
Can we get 1st record through Informatica(without sequence number).
