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
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
When you move from devel to prod how will you retain a variable
Three date formats are there . How to change these three into One format without using expression transformation ?
What is an MDDB? What is the difference between MDDBs and RDBMSs?
What is dimensional table?
What is target load order?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
Repository user profiles
Limitation of REPLACESTR. Is there any character limitation to it.
How to extract the informatica rejected data?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me