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))
Answer Posted / snjsngh15
Based on the constraint based load we can load the data IT means emp table in target t1 and dept in target t2.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can repository reports be accessed without sql or other transformations?
What all join we can perform in LOOKUP transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are some examples of informatica etl programs?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is meant by incremental aggregation?
Explain lookup transformation is active in informatica
How to handle decimal places while importing a flatfile into informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is substr in informatica?
how to load rows into fact table in data warehouse
What is workflow manager?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Whats there in global repository