Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1906 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is a parameter When and where do you them when does the value will be created
I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000
What is workflow? What are the components of workflow manager?
how can u approach u r client
What is the difference between view and materialised view?
Which kind of index is preferred in DWH?
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
what are the difference between Informatica 7.1 and 8.1?
From where we can start or use pmcmd?
can we create index and drop index in exsisting table while using infomatica
Teradata 
