how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
1699in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
TCS,
1655write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
TCS,
2 4933write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
HP,
2 5281write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
4 8467write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
5 9848how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
CTC,
4 24410write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
2 5844write 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
1 2686wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15
3 6380write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
4 7476in 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
1741what is the difference between copy object import objects using repositery manager which one is best
TCS,
1 34083.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
TCS,
1760in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
3 6163Post New Informatica Questions
Explain lookup transformation in informatica
Describe the impact of several join conditions and join order in a joiner transformation?
What is persistent lookup cache?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What does update strategy mean, and what are the different option of it?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Explain the use of aggregator cache file?
What is the difference between router and filter?
Could you explain what is enterprise data warehouse?
What is a stored procedure transformation?
What is the need of an ETL tool?
Different circumstance which drives informatica server to expel records?
How many dimensions are there in informatica?
Can informatica load heterogeneous targets from heterogeneous sources?
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