what is the diff b/w target load plan and cbl?
Answer Posted / brahmareddy
cbl specifies the load order in to the number of targets based on primarykey and foreign key.this is vary useful when you r loading data in to snowflake dimentions.
target load order species the order in which data extract from sq tr
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain how to import oracle sequence into informatica?
What is the sequence generator transformation in informatica?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is source qualifier transformation in informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
In informatica workflow manager, how many repositories can be created?
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?
How can a transformation be made reusable?
Is it possible to create multiple domains on a single Informatica server?
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
What is workflow manager?
What are the uses of etl tools?
is it possible to index the data in cache of lkp transformation ?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is sq transformation?