I have a scenario with router transformation. but i dont want
to capture records from default group. how can we achieve
this.
Answers were Sorted based on User's Feedback
Answer / kishor baindoor
Dont connect any out port of router's default group to next
stage.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / ankita jain
Just ignore the data from default group.. means dont connect to it. See below example for more details
http://www.tutorial.tecktricks.com/example-of-router-transformation-in-informatica-example-1/
| Is This Answer Correct ? | 1 Yes | 0 No |
what are challenges that you faced in testing? give solution to it?
What is dimensional table? Explain the different dimensions.
How can we get two output ports in un-connect transformation?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
What are the basic needs to join two sources in a source qualifier?
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
Explain transaction control transformation in informatica
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
Enlist the tasks for which source qualifier transformation is used.
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
How can you change from reusable session into non-reusable session.
Can i create a lookup table without cache.