can we use bulk loading when we use look in mapping
Answer / sayan
yes we can use bulk load if we are using static lookup.
condition: 1. we are not using a dynamic lookup on the target table. 2. There is no duplicate in the record in the data.
| Is This Answer Correct ? | 0 Yes | 0 No |
How can we use batches?
Can I create one wrkflw which will run different wrkflws on schedule time?
What are mapplets? How is it different from a Reusable Transformation?
HOW TO DELETE A RECORD FROM FLAT FILE
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
How to implement security measures using repository manager?
what is the architecture of any Data warehousing project?
If we have lookup table in workflow how do you trouble shhot to increase performance?
What is a command that used to run a batch?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
permutations of mapplet