What is the benefit of session partitioning?
No Answer is Posted For this Question
Be the First to Post Answer
explan ur project architecture?
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
Target increases every day even though no new record was inserted
Where are the source flat files kept before running the session?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
Kimball and Inmon methodologies?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
What is a test load?
what is difference between mapping and mapplet ?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target