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 |
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
which one is better performance wise joiner or look up
What are 2 modes of data movement in Informatica Server?
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
I want skip first 5 rows to load in to target? what will be the logic at session level ??
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
What is powercenter on grid?
can u give example for factless fact table
Whats the difference between informatica powercenter server, repositoryserver and repository?
what is data driven in update strategy transformation?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.