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 is a stored procedure transformation?
What is the function of aggregator transformation?
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
What are the two modes of datamovement in informatica sever?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the status code in stored procedure transformation?
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
Differentiate between reusable transformation and mapplet.
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000