Interested to Buy Any Domain ? << Click Here >> for more details...
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
IBM,
4 21280There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
IBM,
7 12493My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
3 9381How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
1 7019I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
IBM,
1 4694Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
IBM,
3 8721there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
3 6364Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
IBM,
3 7578i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
3 7087If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
TCS,
3 7158Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
1858Post New Informatica Questions
What is data transformation manager process?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How can we use mapping variables in informatica? Where do we use them?
What is aggregator transformation in informatica?
How can we remove the duplicates from flat file source?
What does “tail –f” command do and what is its use as an Informatica admin.
What is the session task and command task?
What is the Process to creating lookup transformation in informatica
Explain lookup transformation source types in informatica
What is difference between a gateway node and worker node?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain dynamic target flat file name generation in informatica
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
where to store informatica rejected data?
