Question { TCS, 8584 }

i have 1000 record flat file source i want 1st row to 1st
target, 2nd row to 2nd target, 3rd row to 3rd target how will
u do? Without using Mod Function? Explain....

Answer

simple before targets put the sequence generator t/f enable cycle option put start value 1 and end vale 3 connect to all three target

Question { Accenture, 8051 }

Design a mapping to get year of join for each employee.

Answer

use TO_DECIMAL(TO_CHAR(COLUM,'YYYY'))

Question { Accenture, 11518 }

Can we combine a flatfile and a database table using an
UNION transformation?

Answer

both the file and table metadata should same then we can join

Question { TCS, 6968 }

Difference Between ETL & ELT?

Answer

ETL:- ETL MEANS FIRST EXTRACT DATA FROM SOURCES AND TRANSFORMS DATA FOR DESIGNED FORMAT THEN LOAD THE DATA IN TO TARGET

IN THIS ETL THE DATA MOVING 2 TIME IN THE NETWORK
1 SOURCE TO STAGGING
2 STAGGING TO TARGET

ELT: ELT MEANS FIRST EXTRACT THE DATA FROM SOURCES AND LOAD IN TO TARGET THEN TRANSFORM DATA FOR DESIGNED FORMAT

HERE DATA FIRST LOAD IN TEMPERY TABLES AFTER TRANSFORM THE DATA THEN LOAD IN TO PERMENT TABLES

IN THIS ELT THE DATA MOVING 1 TIME IN THE NETWORK

Question { 6192 }

My source contains 10 records with 5 columns.What happens if I
select group by all columns in Aggregator T/R?

Answer

ALL RECORDS SEND TO NEXT T/R

Question { 5327 }

Define Incremental Aggregation?

Answer

IF THE SOURCE CHANGES ONLY INCREMENTLY AND U CAN CAPTURE THOSE CHANGES

YOU CAN CONFIGURE THE SESSION TO PROCESS ONLY THOSE CHANGES

Question { Wipro, 7647 }

There are 4 source files which contains same metadata create target that should display the file name along with record
please send answer with mapping

Answer

double click the source go to properties tab check the
"ADD CURRENT PROCESSED FILE NAME PORT"