Interested to Buy Any Domain ? << Click Here >> for more details...
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
2 6782I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
3 13676while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
2 6826Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
1 6847if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
2 6713Post New Informatica Questions
Enlist the various types of transformations.
Do you find any difficulty while working with flat files as source and target?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What does role playing dimension mean?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the differences between oltp and olap?
what is the complex transformation you used in informatica
Enterprise data warehouse your projects phase by phase explain?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
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.
State the differences between sql override and lookup override?
draw informatica architecture 8.6 ?
Write the different tools in the workflow manager?
How many ways are there to do 'remove duplicate records in informatica'?
