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       
Suggest New Category 
 


 

  Question  Asked @ Answers Views     select
 
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  65
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  1  246
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  129
guys which is the best institute in banglore to learn informatica??  1  156
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  682
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  1067
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier. Eureka-Forbes  3  796
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env? Rolta  1  432
scenario where i can use only concurrent execution of workflow.  0  92
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin  1  513
what is the difference between mapplet & stored procedure?  1  307
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table. IBM  2  571
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?  0  109
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses motorola  1  231
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep Inautix   3  818
E-Mail New Answers        Answer Selected Questions        Post New Informatica Question
 [1]    2  ... 9   ... 17   ... 25   ... 33   ... 41   ... 49   ... 57   ... 65   ... 73   ... 81   ... 89   ... 97   ... 105    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views Asked at   Select
 
what are the challenge face in u r project?explain me 176 iGate
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records 153  
can u give example for factless fact table 1230 TCS
Plz can any one say me how to get the informatica certification materials and dumps 187 TCS
what is $$$$? 171 TCS
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why? 1916 AMDOC
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance 197  
What is Cognos script editor? 1286  
What is the difference between writing a joiner query in ANSI style and THETA style? 254 TCS
what are 3 tech challenges/ common issues you face? 125 TCS
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6 281 Cap-Gemini
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..? 1239 Zensar
E-Mail New Answers        Answer Selected Questions
 
 
 
 
 
 


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

ALLInterview.com   ::  KalAajKal.com