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 the tasks that Loadmanger process will do?
How can you change from reusable session into non-reusable session.
How does the server recognize the source and target databases. Elaborate on this.
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
in which situations do u go for starflake schema ?
What is the difference between a repository server and a powerhouse?
Explain why we use partitioning the session in informatica?
How the facts will be loaded? explain
in which situations do u go for sequence generator ?
What are the types of schemas we have in data warehouse and what are the difference between them?
Define sessions in informatica etl?
what is parallel querying and what r hints.