Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
1979,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
3 80082,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
2 6379there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
1 4859My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
6 11839-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
TCS,
1 5791i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
3 9097Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
7 11043I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
1 9031Post New Informatica Questions
What is fact table? Explain the different kinds of facts.
What all join we can perform in LOOKUP transformation?
On which transformations you created partitions in your project?
Explain the informatica workflow?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Where are the source flat files kept before running the session?
What is sequence generator transformation in informatica?
What is the status code in stored procedure transformation?
Define pmcmd command?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How do you change a non-reusable transformation to reusable transformation?
What are the new features of informatica 9.x in developer level?
How might you approve all mappings in the archive all the while?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How to do unit testing in informatica?