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
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
why we use stored procedure transformation?
In warehouses how many schemas are there?
What is the benefit of session partitioning?
what is DSS?
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
How You Pull the records on daily basis into your ETL Server.
What are the differences between source qualifier and joiner transformation?
how to connect two or more table with single source qualifier?
What is different between the data warehouse and data mart?
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?