i had a source containing business,sales,details column and
i have to load it to a target but i have some bad records
in it , but i have to load 70% of business records and 50%
of sales and 95% of details records excluding bad records
to achieve this what should be done and what all logic and
tx should be used can anyone help? thanks in advance
No Answer is Posted For this Question
Be the First to Post Answer
How do you create single lookup transformation using multiple tables?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
What is an incremental loading? in which situations we will use incremental loading
What are the methods for creating reusable transforamtions?
What are the static cache and dynamic cache in informatica?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
What is substr in informatica?
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
Design a mapping to get year of join for each employee.
What is a test load?
If I am having 6 flat files in data. How can you load the data at a time