I have worked on Informatica 7.1.1. I want to know the
answer for the below question.
Target is not created initially.Then how to take the DDL
script from the source and run the Mapping by creating the
Target dynamically?Is it possible by SQL Transformation?
- 0 Answers
- 1462 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is a shortcut and copy in Informatica and how two are different with each other?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow
can you use flat file for lookup table?why?
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
Explain pushdown optimization $pushdownconfig parameter - informatica
How do you use reject loader.
How do you load first and last records into target table?
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
What is the difference between normal and bulk loading? Which one is recommended?
What is an aggregator transformation? it is active why cant it be passive explain?
in which situations do u go for snowflake schema ?
Teradata 
