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
   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
Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y    2  8
What is Collect performance data in informatica and what is the use of it.    1  21
Scenario:-  Below is the requirement. Source:-  NAME          ID                    Requirement  RAVI            1                      (no need to repeat as it ID is 1) KUMAR        3                     (repeat 3 times as it ID is 3) John             4                     (repeat 4 times as it ID is 4) Required Out Put:- Name                   ID RAVI                     1                    KUMAR                3      KUMAR                3 KUMAR                3  John                     4 John                     4 John                     4 John                     4 Scenario 2:- Source Data  ID              NAME 1,2            NETEZZA,ORACLE 3,4,5         SQL Server, DB2, Teradata Required Output:-  ID                   NAME 1                  NETEZZA 1                  ORACLE 3                  SQL Server 3                  DB2 3                  Teradata    1  17
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it    0  21
how to get max value record into one target and remaining records into another target? accenture   1  68
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time. barclays   3  74
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow? tcs   4  91
What is informatica? What exactly are the practical uses in real world    1  113
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help axtria   1  179
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours) atriax   2  393
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.    0  209
guys which is the best institute in banglore to learn informatica??    1  239
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change? tcs   1  830
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target) tcs   3  1212
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier. eureka-forbes   3  936
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    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views   Select
 
in reporting we add some new objects,how we get the count of the newly added objects to the report 358
HOW TO FIX THE ETL BUGS..TELL ME THE PROCESS? 250
explain about unit testing? in real time? 128
What is Cognos script editor? 1316
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve? 1105
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do 206
what are 3 tech challenges/ common issues you face? 139
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION 171
can we use self join in informaitca? 2570
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues? 228
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario. 257
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap. 234
How u use pdf file in informatica source? 896
Plz can any one say me how to get the informatica certification materials and dumps 190
I HAVE A TEXT FILE NAME X WITH A TEXT MESSAGE. WORD INFORMATICA IS REPEATED FOR N NUMBER OF TIMES. HOW TO COUNT THE NUMBER OF OCCURANCE OF WORD INFORMATICA OF WORD INFORMATIC IN THIS FILE X. 255
E-Mail New Answers        Answer Selected Questions