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
   Testimonials Refer this Site  Refer This Site to Your Friends  Site Map  Contact Us      
   
 
 Categories >> Software >> Data Warehouse >> Informatica
 
Suggest New Category 
 


 

Question Asked @ Answers Views     Select
what is the difference between repository & Intergration service    1  22
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?    0  53
How to read data from flat file source if the data is in paragraph format?    0  36
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?    2  89
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance    0  84
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario    4  218
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no    2  163
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?    1  113
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?    2  109
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z    0  67
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...    2  215
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.    0  100
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .    0  95
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.    1  193
What is deployemnt groups, Lables, query and dynamic deployment group.    1  376
E-Mail New Answers        Answer Selected Questions        Post New informatica Questions
 [1]    2  ... 9   ... 17   ... 25   ... 33   ... 41   ... 49   ... 57   ... 65   ... 73   ... 81   ... 89   ... 97   ... 105   ... 113    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views   Select
 
Global and Local shortcuts. Advantages. 122
Slowly changing dimensions, types and where will you use them 122
what is song in infrmatica...? 467
In which scenario did u used Mapping variable? 431
can u any challenge your project? 500
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com 2587
waht type of interface is used for testing the data in informatica 569
lookup transformation with screenshots 2124
explain one complex mapping with logic? sales project? 2499
tell me 5 session failure in real time how can you solve that in your project? 472
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP.  1301
what is mean by complex business rule ? 453
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup? 3044
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running. 270
Repository user profiles 192
E-Mail New Answers        Answer Selected Questions