what are the limitations for bulk loading in informatica for
all kind of databases and transformations?
Answers were Sorted based on User's Feedback
Answer / sujana
v need to disable constraints while performing bulk loading
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / sunil
Bulk load is used for external loaders and in bulk load we
will not write information to datalog file so if any
recovery is needed it is not possible
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / vikas
1.update strategy
2.no constraints on target
3.target should be relational database
4.less number of records
Is This Answer Correct ? | 2 Yes | 0 No |
How can we eliminate duplicate rows from flatfile,explain?
Difference between task flow and linear task flow
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
Which is the t/r that builts only single cache memory?
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
how to connect two or more table with single source qualifier?
in which situations do u go for scds ?
What are Rapid changing dimensions?
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
What are the modules in Power Center