Question { Wipro, 15832 }

i have flat file it contains 'n' number of records, i need
to send half of the records to one target table and
Remaining half to another target table: pls full details

Answer

CREATE A MAPPING VARIABLE WITH AGGREGATION TYPE AS COUNT.
DEFINE ITS INITIAL VALUE AS 0.
THEN IN EXPRESSION CREATE AN OUTPUT PORT.
COUNT-SETCOUNTVARIABLE(VARIABLE NAME).
USE AN AGGREGATOR TO FIND THE TOTAL NO F RECORDS.
IN ROUTER
CREATE TWO GROUPS
IN FIRST GROUP ENTER CONDITION
COUNT<=(TOTAL NMBR F RECORDS)/2
IN SECOND GROUP ENTER CONDITION
COUNT>(TOTAL NUMBER F RECORDS)/2.

SEHAJ....

Question { 7983 }

what is incremental aggregation ,with example?

Answer

Incremental aggregation is nothing but a method of maintaing
new records in the target when we use an aggregator in our
mapping..
With incremental aggregation only those records which are
new in the source are processed in the mapping excluding
those which have been processed.
The data which was earlier present in the source n has been
processed is stored in the cache and the new records are
processed along with them.
For this we need to select the option INCREMENTAL
AGGREGATION from session properties.

Question { TCS, 7552 }

my source contain data like this
cno cname sal
100 rama@gmail.com 1000
200 karuna@yahoo.com 2000
i want load my data to the target is
cno cname sal
100 rama 1000
200 karuna 2000
plz send the answer

Answer

DO ONE THING....
CREATE AN EXTRA PORT FOR THAT.
IN THE EXPRESSION EDITOR,WRITE

REPLACESTR(0,cname,(SUBSTR(cname,INSTR(cname,'@'),INSTR(cname,'m',-1,1)),'')

PASS THIS PORT TO THE OUTPUT PORT......


SEHAJ-7204719446

Question { 5947 }

what is the max/min size allocated for caches.whether index
or datacache in any of the transformations like Joiner or
Aggregator.bcoz it is set to Auto by default which means we
need not to allocate no of bytes or MB.so what is the use of
these properties.please let me know about the caches.

Thnaks in advance
Sai Ram

Answer

MIN SIZE FOR INDEX CACHE IS 1MB
N DAT OF DATA CACHE IS DOUBLE OF THAT

IN AGGREGATOR..THE AUTO PROPERTY PERFORMS THE FOLLOWING
FUNCTION...
SUPPOSE WE HAVE CHOOSED THE SIZE TO BE 8 MB N THE SESSION
UTILIZES ONLY 3 MB SO IF WE SET THE PROPERTY TO AUTO IT WILL
SET THE CACHE SIZE AUTOMATICALLY TO 3MB.

Question { Wipro, 5240 }

Can anyone please distinguish what is Inner join and Outer join

Answer

INNERJOIN-GIVES THAT RECORDS THAT ARE PRESENT IN BOTH THE TABLE
OUTERJOIN-GIVES THAT RECORDS WHICH ARE PRESENT AND ALSO
WHICH ARE NOT PRESENT IN ONE OF THE TABLE.

INEERJOIN-REQUIRES LESS PROCCESING TIME.
OUTERJOIN-REQUIRES THE MAX PROCESSING TIME AMONG ALL THE
KIND O JOINS.

Question { TCS, 6095 }

how we can update a target table without update strategy and
update override?

Answer

BY USING DYNAMIC LOOK UP CACHE!

Question { TCS, 7517 }

2,can we insert duplicate data with dynamic look up cache,if
yes than why and if no why?

Answer

DUPLICATE DATA CANOT B INSERTED USIN DYNAMIC LOOK UP
CACHE..BCOZ DYNAMIC LOOK UP CACHE PERFORMS ONLY UPDATE N
INSERT FUNCTION BASED ON THE KEYS IT GETS IN THE TARGET
TABLE N LOOK UP TABLE...

Question { Zensar, 10449 }

Can we insert ,update ,delete in target tables with one
update strategy tran.?

Answer

WE CAN UPDATE INSERT ROWS INTO TARGET TABLE USING SAME
UPDATE STRATERGY IN A SESSION BUT WE NEED TO SELECT THE
OPTION UPDATE ELSE INSERT OPTION FROM SESSION
PROPERTIES>MAPPING.
BUT WE CAN INSERT UPDATE N DELETE,I MEAN PERFORM ALL THREE
AT A TIME.

Question { Satyam, 4461 }

we have to use order by,where,having we to implement sql query

Answer

IN A QUERY WE CAN USE ALL THE THREE....BUT USING WHERE N
HAVIN DOESN MEAN ANY SENSE...
IF WE USE GROUP BY WE CAN USE WHERE CLAUSE BEFORE GROUP BY
PORT...
AND IF WE USE GROUP BY WE CAN USE HAVING AFTER GROUP BY CLAUSE..
N GENERALLY ORDER BY CLAUSE IS ALWAYS WRITTEN AT THE END OF
THE QUERY

Question { 3146 }

tell me 7.x and 8.x diferrencess(but not transformations)

Answer

1)7.X IS SERVER ORIENTED
8.X IS SERVICE ORIENTED
2)7.X DOESNT CONTAIN ANY OPTION LIKE DYNAMIC FILE NAMING
WHEREAS 8.X CONTAINS AN OPTION LIKE DYNAMIC FILE NAMING
3)WE CAN CREATE USER DEFINED FUNCTIONS IN 8,X
4)SERVER FOLDERS NEED NOT BE CREATED IN 8.X.
5)TARGET DEFINATION CAN BE CREATED IN 8.X WITHOUT IMPORTING
TARGET IN THE MAPPING DESIGNER.
6)ONLY INFORMATICA SERVICE NEEDS TO BE STARTED IN 8.X WHERE
AS IN 7.X REPOSITORY SERVER N INFORMATICA SERVER NEEDS TO
BE STARTED BEFORE WORKING.
7)ADMIN CONSOLE OPENS IN AN INTERNET EXPLORER BROWSER.
8)SEQUENCE GENERATOR USES AN DATATYPE CALLED BIG INT.
9)MAX LIMIT OF SEQUENCE GENERATED CAN BE 8000000000+
10)THERE IS NO NEED OF CHANGING THE SERVER SETTINGS EACH
TIME WHEN DIFFERENT USER SITS ON THE MACHINE TO WORK IN HIS
REPOSITORY N SERVER....


SEHAJ......7204719446

Question { Accenture, 20078 }

How to improve the session performance in informatica?

Answer

MR GYANA RANJAN BEHERA.....CAN U TELL ME WHEN WE ARE USIN
SESSION IN BULK MODE THEN WHAT IS THE NEED OF SETTIN D
BUFFER BLOCK SIZE ?

Question { Satyam, 7841 }

i have thousand records in my source(flat file) i wanna load
990 records i don't want load first 5 records and last 5
records at informatica level?

Answer

PASS RECORDS FROM SOURCE QUALIFIER TO EXPRESSION.
CREATE A VARIABLE WITHA GGREGATION AS COUNT N ASSIGN ITS VALUE AS 0.
CREATE TWO PARAMETRES N ASSIGN DEM VALUES.
FIRST ONE 5
SECOND ONE 995
.
IN EXPRESSION CREATE AN OUTPUT PORT AS NUMBER DATATYPE N IN THE EXPRESSION EDITOR WRITE....
SEQUENCE=SETCOUNTVARIABLE(VARIABLE NAME U CREATED).

NOW
ATTACH IT TO THE ROUTER
CREATE A GROUP AND ENTER CONDITION
SEQUENCE>5 AND SEQUENCE<995
CONNECT THIS PORT TO TARGET...

SEHAJ....

Question { IBM, 8065 }

What are events in workflow manager?

Answer

EVENTS ARE THE WAIT WHICH V IMPLEMENT ON OTHER TASKS ON WF BEFORE THE SPECIFIED REQUIREMENT IS FULLFILLES.
THESE ARE OF TWO TYPES
1.PREDEFINED(ALSO CALLED FILE WATCHER EVENT)
2.USER DEFINED

IN PREDEFINED WE CAN CHECK FOR A FILE TO BE PRESENT IN A PATH WE SPECIFY BEFOE V PROCEED WITH THE WF.

IN USER DEFINED WE CAN MAKE ANY TASK TO WAIT BEFORE A SPECIFIED TASK IN COMPLETE.
IN USER DEFINED EVENT WAIT N EVENT RAISE TASK ARE USED IN COMBINATION.

SEHAJ

Question { Logica CMG, 7588 }

How to add source flat file header into target file?

Answer

IN 7/8 WE CAN GO TO SERVER SETUP N CHOOSE A PROPERTY FROM THERE WHERE READS AS
"CREATE METADTA FOR FLAT FLIE"

IN 8.6 WE CAN SET ITIN SESSION PROPERTIES...OPEN SESSION PROPERTIS
THEN IN TARGET CHOOSE THE HEADER PROPERTY WHERE V DEFINE THE PATHNAME N ALL FOR THE FLAT FILES.