can we see default group,when we use router?if yes how?
Answers were Sorted based on User's Feedback
Answer / murthy
Yes..we can use Default group..all the records that doesnt
meet the conditon comes to this default group..just connect
it to any other transforemation and use it acc to ur reqmnt.
Is This Answer Correct ? | 11 Yes | 1 No |
Answer / sweta kedia
Yes we can see the default group. Wen we add router, there r
no groups. Wen we add any group,then a default group is also
added.We can add conditions for this group according to our
requirement. If we do not give any conditions,all the
records that doesnt meet the conditon comes to this default
group. Just connect it to any other transformation and use
it acc to ur reqmnt.
Is This Answer Correct ? | 1 Yes | 0 No |
What are the different types of olap? Give an example?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
How do you implement configuration management in Informatica?
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
can any one explain me about junk dimension
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
what is junk dimension
What are two types of processes that informatica runs the session?
How to update a particular record in target with out running whole workflow?
how to create user defined function (udf) in informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?