Interested to Buy Any Domain ? << Click Here >> for more details...
Hello ,
I am unable to work with SQL transformation at least.
Where do i need to give connection for sql transformaton ?
At session level there is no property .
I have created a SQL Transformation and chosen query mode.
But do i need to pass connection information to it ? I
don't know where do i need to write a query ?
I have written a query in file and that file path i gave in
the properties of SQL Transformation.
But it is not working.
Could any one of you please let know how can i work with
SQL Transformation?
Advance Thanks.
- 0 Answers
- 2860 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
I want skip first 5 rows to load in to target? what will be the logic at session level ??
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
What is Datadriven?
What are the uses of a Parameter file?
can we override a native sql query within informatica? How do we do it?
diffrence between command task and control task
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
How to do Integration testing in Informatica?
What is an expression transformation?
Teradata 
