Is there any way to read the ms excel datas directly into informatica?
No Answer is Posted For this Question
Be the First to Post Answer
Why we use stored procedure transformation?
How to import oracle sequence into Informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Why do you use Mapping Parameter and mapping variable?
While migrating the data from one environment to another environment how would you manage the connections?
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.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
What are different types of transformations available in informatica?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
how to identify new and old values in source qualifier or any other transformations using informatica
Explain the scenario which compels informatica server to reject files?