ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Data-Warehouse >> Informatica
 
 


 

Back to Questions Page
 
Question
can we use self join in informaitca?
Rank Answer Posted By  
 Question Submitted By :: Bharathi
This Interview Question Asked @   IBM
I also faced this Question!!   ALL Interview .com
Answer
Yes we can use self join informatica using SQL override..
and remember Joiner transformation does not support for self
join..
 
0
Krishna
 
 
Answer
However joiner Trans does not support self join , but you can achieve similar functionality with the following steps.
1) create two expression transformation and input them using Source Qualifier.
2) Pull joiner transformation and join both two expression transformation using keys like mgrno = empno
3)NOTE:- check sorted input box and pull your data as ordered.

http://deepinopensource.blogspot.in/
 
0
Ankit Kansal
 
 
Question
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
Rank Answer Posted By  
 Question Submitted By :: Sai Ram
I also faced this Question!!   ALL Interview .com
Answer
Data cache size is between 2MB to 24MB.

Index cache size is between 1MB to 12 MB.
 
0
Srinivas Bolusupati
 
 
 
Answer
INDEX CACHE IS MIN IN SIZE AND DATA CACHE IS MAX IN SIZE
 
0
Venkateshmalneni
 
 
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.
 
0
Sehaj
 
 
Question
why we use informatica in our project?
Rank Answer Posted By  
 Question Submitted By :: Mehul.thakur
This Interview Question Asked @   TCS
I also faced this Question!!   ALL Interview .com
Answer
this is a stupid Question,
informatica is a ETL tool which is extract,transfoemation,and load data from source to target,bcz our project based on informatica tool so we used
 
0
Pradosh
 
 
Answer
At Knack systems we use Informatica to make data migration 
projects more standardized, repeatable, and consistent. 
Whether they are rationalizing, integrating, upgrading, or 
migrating to enterprise applications, Our teams can reduce 
project risk and cost and improve project predictability 
with Informatica.

Informatica makes projects less risky, reduce costs, and 
shorten their project cycle Times . It enables users to 
migrate more data of a higher quality faster, which means 
that we can deliver their projects at a lower cost, on 
time, on budget, and without reductions to scope
 
0
Ramesh
 
 
Question
can we use cartesian join in informatica
Rank Answer Posted By  
 Question Submitted By :: Bharathi
This Interview Question Asked @   IBM
I also faced this Question!!   ALL Interview .com
Answer
No we can,t use cartesian join in informatica
 
0
Raju
 
 
Answer
we can use Cartesian join in  informatica by using full outer 
option in joiner t/r


if am wrong please let me know
 
0
Venkateshmalneni
 
 
Answer
yes we can ,by creating dummy ports in expression transmission like forjoin and tojoin ,in joiner transformation condition is forjoin=tojoin and output is m*n format
 
0
Rajesh
 
 
Question
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
Rank Answer Posted By  
 Question Submitted By :: Narender.vankuri
This Interview Question Asked @   TCS
I also faced this Question!!   ALL Interview .com
Answer
above answer only for the first time data loading only for new 
record inserts to source it gives false results
 
0
Vijaya
 
 
Answer
Hi am Narender Reddy take an example:Dept table 

Source->source Qualifier->After this we take one Aggregator and one Expression -> and both of this connected to Joiner -> this connect to Router->Here we take one Sequence generator and connect to Router-> this router connect to Targets

Here we see conditions:
1)   In Aggregator create Cnt Port and(No input ,only   output)     There expression Condition(COUNT(DeptNo)
In this create One extra port Decimal express:1(no input,only output)
Disable Groupby
2)   In Expression create one extra port decimal expression:1
this 2 transformations(Aggregator,Expression) are connected to Joiner
3)In Joiner Enable SorterInput,Condition And connect to Router Input.
4)Take one Sequence Generator and connect to Router Nextval
5)In Router Group1:Nextval<=(Cnt/2)
6)In Router Group2:Nextval>(Cnt/2)
7)Now connected to Traget1,Target2.

ThankYou
V.Narender Reddy
 
0
Narender.vankuri
[Hcl]
 
 
Question
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104
MY REQUIRMENT IS 
NAME       ID
VENKATESH 101
RAJESH    102
SIVA      103
SWATHI    104

PLEASE PROVIDE ME THE SOLUTION
Rank Answer Posted By  
 Question Submitted By :: Venki.malneni
I also faced this Question!!   ALL Interview .com
Answer
two types
treat consecutive delimiters as one in import from flat file
then use a normalizer transformation you will get the answer

second type in unix scripting you can get the o/p
 
0
Vijaya
 
 
Answer
hai vijaya 


will u please explain me in detail
 
0
Venkateshmalneni
 
 
Answer
Separate VENKATESH ,101  
         Rajesh,102 
         Siva ,103  by using "||" as delimiter .


Then in the expression Divide the string Venkatesh ,101 intto two separate variable using string operation  and output that two separate columns of the target
 
0
Saket
 
 
Answer
when at the time of this kind of situation we can normally
import the source definitions by treat consecutive
delimiters as one and use the normalizer transformation and
set occurenc
as one and connect those ports to next transformations.
 
0
Sreekanth
 
 
Question
1)what is the use of bottlenecks in informatica.

2)where we are use shellscripting.

3)what meant by informatica.
Rank Answer Posted By  
 Question Submitted By :: Vanamadhu.dwh@gmail.com
This Interview Question Asked @   CTS
I also faced this Question!!   ALL Interview .com
Answer
1) Following are the some of bottlenecks in informatica..

(i) source bottlenecks
(ii)Target bottlenecks
(iii)Mapping bottlenecks
(iv) system bottlenecks

3)Informatica is one of most popular ETL tool...it will extract the data from the different sources and it will transform the data as per business logic and then it will load the data into different targets..
 
0
Urs
 
 
Question
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.
Rank Answer Posted By  
 Question Submitted By :: Vanamadhu.dwh@gmail.com
This Interview Question Asked @   CTS
I also faced this Question!!   ALL Interview .com
Answer
2)i have number of records in my sourse, but iwant to
display first and last record only. how it is possible in
informatica.

ans:yes we get first and last record from table using 
psuedo columns rownum and row id
i.e.,
in source qualifier t/r we caen create user defined queires
their type below query 
select * from <table_name> where rownum=1 union select *
from <table_name> where rowid=(select max(rowid) from
<table_name>);
note:<table_name> is the name of the from which u want to
retrieve records
 
0
Kishore
 
 
Answer
How to generate sequence numbers in informatica with out using sequence generator t/r

we can generate sequence numbers in informatica by using expression transformation also.In expressin t/r create 3 new ports 
1)var_1 as variable port and in expression give value as val
2)val as variable port and in expression give value as val+1 
3)sequence output port and in expression give val
 and connect the output port to target
 
0
Venkateshmalneni
[CTS]
 
 
Answer
i have number of records in my sourse, but iwant to
display first and last record only. how it is possible in
informatica.
 
Generate sequence numbers to ur source
connect it to filter t/r and write a condition sno=1 connect it to the target

in second pipeline connect source qualifier to aggreator t/r don't select any group by (so that it will gives it last record) connect output to the target

the flow is like this
sequence generator|
                  |
                 \|/           
src--->sq--->filter--->target
        |
        |--->aggrigator--->target
 
0
Venkateshmalneni
[CTS]
 
 
Answer
We can generate using MAPPING VARIABLE with SETCOUNTVARIABLE() function
 
0
Rakesh
[CTS]
 
 
Answer
HI VENKATESH,

        YOUR ABOVE ANSWER IS NOT CORRECTLY WORKING IN MY
SYSTEM. SO PLEASE EXECUTE THE ABOVE SOLUTION ONCE AGAIN LOAD
IT. AS PER MY KNOWLEDGE WE CAN CREATE A MAPPING VARIABLE AS
$$SEQ,DATA TYPE IS INTEGER AND SELECT AGGREGATION COLOUMN IS
COUNT. USING EXP TRANSFORMATION SETCOUNTVARIABLE($$SEQ). IT
WILL WORK CORRECTLY.
 
0
Chandrasekar
[CTS]
 
 
Question
i have a source with 100 records.i have 2 targets.in the first 
target i want to load first 50 records & in the second target 
i want to load next 50(or remaining) records.
Rank Answer Posted By  
 Question Submitted By :: Lavi
I also faced this Question!!   ALL Interview .com
Answer
Mapping structure
=================

source-->sq-->sequence-->exp-->router-->target1
                                     |-->target2


1)Pass the seq genarator "nextval" port to expression.
2)through expression t/r pass the variable port to router
3)In router create two groups

  Group1:nexval<=50-->this group conneted to target1
  Groutp2:nexval>=50-->this group conneted to target2
                     
                    or


  default group connected to target2

Note: This logic only that source data contain 100 records.


If you any quires please ask.


Best Regards,

Mukunda
mukunda.velluri@gmail.com
 
0
Mukunda
 
 
Answer
Hi Mukunda,
U r correct but, y u are using addional t/r Exp, without 
EXP we will make this mapping scenario,

I made it actually, that is the way i am sending this
like as follow

              SQ-Gen-|
                     | 
Source--> SQL------>RTR->Target1
                     |
                     |--->Target2

In SQ-Gen:
    Change the Startvalue, Endvalue and Check the CYCLE and 
RESET option in the properties of SQ-Gen
popuklate the NEXTVAL from Seq_gen to RTR.

In the RTR t/r: 
(as my scnario the 3 records will load tgt1 and next 3 will 
load in tgt2 and next 3 will load in again TGT1 and so on..)
   2 groups
   one is NEXTVAL <= 3
   and NEXTVAL >= 4 
and populated these groups to ur target accordingly.

Thanks & Regards
Balakrushna
 
0
Balakrushna
 
 
Question
why union transformation is active transformation?
Rank Answer Posted By  
 Question Submitted By :: Sravanthi
This Interview Question Asked @   TCS
I also faced this Question!!   ALL Interview .com
Answer
If the source1 has 10 records and the it contains 3 records 
and the same 3 records are in the second source,the second 
source contains 10 records if we want to join them using union 
t/r then the output is 17 records instead of 20 records.
thats why we say that UNION T/R is active t/r
 
0
Venkateshmalneni
 
 
Answer
Active transformation means recieve n number of records and
return < or > that of n number of records.
Union transformation is Active transformation because it
return less than that of recieved records.
 
0
Hanumantharao
 
 
Answer
Since union is derived from Custom T/R which is of type Active.
 
0
Rock
 
 
Answer
Hai frnds,
According to my knoweledge,active t/f means which changes the number of rows that can pass through it.
coming to why union t/s is active.......because union t/f merges the data which is coming from two sources,it means that it summarizes the data which is passing through union t/f,with this the no.of rows coming from that will be less....
so it is an active t/f...

Thanks.....Raji
 
0
Raji
 
 
Answer
Hi,
the only condition for a transformation to bcum active is
row number changes.
Now the thing is how a row number can change. Then there are
2 conditions:
1. either the no of rows coming in and going out is diff.
eg: in case of filter we have the data like
id name dept row_num
1 aa 4 1
2 bb 3 2
3 cc 4 3
and we have a filter condition like dept=4 then the o/p wld
b like

id name dept row_num
1 aa 4 1
3 cc 4 2

So row num changed and it is an active transformation



2. or the order of the row changes
eg: when Union transformation pulls in data, suppose we have
2 sources
sources1:
id name dept row_num
1 aa 4 1
2 bb 3 2
3 cc 4 3
source2:
id name dept row_num
4 aaa 4 4
5 bbb 3 5
6 ccc 4 6

it never restricts the data from any source so the data can
come in any manner

id name dept row_num old row_num
1 aa 4 1 1
4 aaa 4 2 4
5 bbb 3 3 5
2 bb 3 4 2
3 cc 4 5 3
6 ccc 4 6 6

so the row_num are changing . Thus we say that union is an
active transformation
 
0
Mahaboob Basha
 
 
Answer
actually union transformation is a passive 
transformation,not an active transformation.
 
0
Sony
 
 
Question
what is bridge tables in informatica
Rank Answer Posted By  
 Question Submitted By :: Dbanu.rbn
This Interview Question Asked @   CTS
I also faced this Question!!   ALL Interview .com
Answer
Bridge table is a association table between two multivalued 
dimension tables i.e. which have many to many relation.
Actually database doesn't support m to m relationship so 
by  using this bridge table we convert the m to m relation 
ship into two 1 to many relationships.Bridge table contains 
primarykeys of both dimensional tables as a compositekey
 
0
Gangam Rajesh
 
 
Question
how can we run workflow with pmcmd?
Rank Answer Posted By  
 Question Submitted By :: Mehul.thakur
This Interview Question Asked @   Wipro
I also faced this Question!!   ALL Interview .com
Answer
FIRST CONNECT TO PMCMD AND THEN TO INT. SERVICE.
TYPE THIS---> STARTWORKFLOW -F FOLDERNAME WORKFLOWNAME
 
0
Vijay Kumar
 
 
Answer
connect to pmcmd,
connect to integration service.
pmcmd>connect -sv service_name -d domain_name -u user_name
-p password;
start workflow,
pmcmd>startworkflow -f folder_name
 
0
Prasad
 
 
Answer
connect unix promt
connect pmcmd
pmcmd>connect -sv service_name -d domain_name -u user_name
-p password
pmcmd> startworkflow -f folder_name workflow
 
0
Mahaboob Basha
 
 
 
Back to Questions Page
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com