in what type of scenario bulk loading and normal loading we use?
- 2 Answers
- 6161 Views
- Cognizant, Wipro, I also Faced
- E-Mail Answers
Answer Posted / venkateshmalneni
We use bulk loading in such senarious where there is bulk amount of data is to be loaded into target.
ie we when we want yo load large amount of data fast into the target we use bulk loading.
when u dont want to do the session recovery and u r target should not contain any primary keys
we use normal loading in such senarious when u want to do session recovery.It looks about the constrain based
loding
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Name the different lookup cache(s)?
What is a sequence generator transformation?
What is lookup transformation?
What is informatica etl tool?
What are the main features of Oracle 8i with context to datawarehouse?
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
wf dont have integration severances how you can run?
What is rank transformation in informatica
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Please let me know how to make encryption and decryption with example?
how many types of dimensions are available in informatica?
What are ETL Tools?
How can you differentiate between powercenter and power map?
Explain the aggregator transformation?
