ALLInterview.com :: Home Page KalAajKal.com
 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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories >> Software >> Data-Warehouse >> Informatica
 
 


 

Back to Questions Page
 
Question
Hi,

If any hav Informatica n DWH FAQ's,Plz do fwd to
vanibv6@gmail.com

Thnx
Vani
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
For more Informatica Interview Questions Click Here
 
0
Earfgwerf
 
 
Question
sir presently i am persuing my m.tech  
recently i got job in tcs as fresher presently iam doing my 
9 months project related to informatica can any one guide 
me how to create fact tables what type of schemas must be 
used and so on if so give ur mail ids so that i can contct 
through it
Rank Answer Posted By  
 Question Submitted By :: Mahesh
I also faced this Question!!   © ALL Interview .com
Answer
Fact tables will created by
(DBA people or senior architects) with PK-FK relation.
Mstly  people will create  PK-FK relation in facts After 
loading the Data in Table).

Schemas : Mostly STAR Schema.

It will be useful for u ,,,,,,,,,,,

srinu.srinuvas@gmail.com
 
0
Srinu
 
 
Question
suppose if we have dublicate records in a table temp n now 
i want to pass unique values to t1 n dublicat values to t2 
in single mapping using aggregator & router? how
Rank Answer Posted By  
 Question Submitted By :: Guru
This Interview Question Asked @   TCS
I also faced this Question!!   © ALL Interview .com
Answer
I have a idea after sql transformation go thruogh 2 Agg 
Trans,2 Router Trans
Agg1-gorup by col count=1 to router trans
Agg2-group by col count<>1 to router trans

I am not confident check itonce let me know,,

Thanks
Srinu
 
0
Srinu
 
 
 
Question
Which is costliest transformation? costly means occupying
more memory?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
Look up Transformatoin only,
its going to maintain existing data also in cach memory
 
0
Srinu
 
 
Question
how to run two workflow(not a sessions) sequentially, what
is the process. Plz explain detailed information.
Rank Answer Posted By  
 Question Submitted By :: Brahma011
This Interview Question Asked @   Keane-India-Ltd
I also faced this Question!!   © ALL Interview .com
Answer
I would use following methods

1. Create a KSH to call (pmcmd startworkflow) two workflows
one after another (or two statements in ksh). And if
required, I can check successful run of previous workflow
before running another.
2. Make use of command object in second workflow. This
object will be based on ksh which can wait on file created
by successful run of first workflow
3. Make use of even wait task as file watcher and watch a
file created by first workflow. 
4. Crude way: Determine workflow execution time. Schedule
two workflows by considering execution time difference.
 
0
JayeshMumbai
 
 
Answer
as per i know
create a worklet and save the workflow in worklet and run 



please let me know is this ans is correct

please call me if this is not an correct 9912063678
 
0
Ganesh
 
 
Answer
The best way is obviously to run WF1 and then call WF2 
using PMCMD command in the last session of WF1(as a post 
session task).If you absolutely want to ensure that the 
second wf starts only after graceful completion of wf1 then 
simply add a command task for the pmcmd and use the piple 
to validate that the previous task is completed properly.

Please let me know if you are not clear or need more info.
Cheers!
 
0
Subash
 
 
Question
how to run 2 workflows sequentially. plz respond what is the
process?
Rank Answer Posted By  
 Question Submitted By :: Brahma011
This Interview Question Asked @   Cap-Gemini
I also faced this Question!!   © ALL Interview .com
Answer
We can do using Event Raise & Event Wait tasks in workflows
 
0
Vijay Reddy
 
 
Answer
we have to create worklet . a worklet  can be used to run
multiple workflows.  a worklet is created with worklet
desinger tool.
 
0
Ganesh Prasad
 
 
Question
what is the monster dimension plz give me one example
Rank Answer Posted By  
 Question Submitted By :: Brahmaiah
This Interview Question Asked @   EDS
I also faced this Question!!   © ALL Interview .com
Answer
Monster dimensions require special handling and advanced 
planning, especially when you’re dealing with rapidly 
changing monster dimensions. Rapidly changing dimensions 
(i.e., dimensions whose content changes as a result of 
input errors or changes over time that you’re recording in 
place) aren’t too much of a challenge when the dimensions 
are small. However, monster dimensions consume large 
amounts of maintenance time and CPU cycles because of their 
size, so you need to plan carefully when you’re dealing 
with them. Let’s explore two different methods for managing 
rapidly changing monster dimensions: first, splitting the 
dimension, and second, creating a set of non-overlapping 
value ranges for each rapidly changing attribute and then 
creating rows that include all possible range combinations.
 
0
Pooja
 
 
Question
which one is costliest transformation? costliest means 
occupying more memory. which one 
Aggregator,sorter,filter,etc..
Rank Answer Posted By  
 Question Submitted By :: Raja
This Interview Question Asked @   TCS
I also faced this Question!!   © ALL Interview .com
Answer
HERE YOU MENTIONED ONLY 3 TRANSFORMATION, SO OUT THESE 3 
aGGREGATOR IS COSTLIEST TRANS
 
0
Pooja
 
 
Answer
hi guys,
 some one  selected that Above ans is worng.. can any one 
tell correct answer.for the above Question
 
0
Savita
 
 
Answer
hey raj, pooja and savita the costliest transformatin till 
Infa7.1.4 is lookup but after Infa 8.1 it guess it sj=hould 
be JAVA.
 
0
Krishna
 
 
Question
Which gives the more performance when compare to fixed 
width and delimited file ? and why?
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   HP
I also faced this Question!!   © ALL Interview .com
Answer
fixed width,because there are no delimiters to check so the 
preformance will increase
 
0
Murthy
 
 
Question
What are the challenges of Dataware housing in the future?
Rank Answer Posted By  
 Question Submitted By :: Krishna
This Interview Question Asked @   HP
I also faced this Question!!   © ALL Interview .com
Answer
Doveloping Programing tools also
 
0
Srinu
 
 
Question
why we use source qualifier transformation?
Rank Answer Posted By  
 Question Submitted By :: Raaja
This Interview Question Asked @   Accenture
I also faced this Question!!   © ALL Interview .com
Answer
source qualifier transformation represent the records that 
the informatica server reads when it runs a session.
 
0
Manoj
 
 
Answer
Source qualifier is the first transformation which reads 
data from relation of FF source.
With SQ we can limit the source data or sort or aggregate 
or remove the dupliate data via SQL Query.
 
0
Ankit
 
 
Answer
hi,
we use SQ trans as 1st trans due to its properties. in SQ 
trans i means at the begin of extracting of data its self 
we can remove duplicate ,we can filter,join,override the 
query,pre and post sql querey.... in orther words we use it 
to impore the performance.
 
0
Pooja Amhed
 
 
Answer
Source Qualifier Transformation basically converts 
different data types to Informatica Compatible Data types. 

The additional Feature of it to allow the developer to 
override the SQL (Only while reading database sources) adds 
better design in the map. [instead of having additional 
Filters and Sorters].
 
0
Vanitha
 
 
 
Back to Questions Page
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com