Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
- 0 Answers
- 2565 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
where is the reject loader .
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Why we use ENABLE HIGH PRECISION in session properties?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
What is the term PIPELINE in informatica ?
without table how to come first record only in oracle?
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
What are set operators in Oracle
What are the types of schemas we have in data warehouse and what are the difference between them?
How to improve the performance of Aggregate transformation?
Teradata 
