Interested to Buy Any Domain ? << Click Here >> for more details...
can a port in expression transf be given the name DISTINCT
- 3 Answers
- 13654 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / my
Yes, it can be used. Port name is just a name and
informatica do not validate the port name as long as it is
unique among all the ports in one particular expression.
| Is This Answer Correct ? | 24 Yes | 0 No |
Answer / rao
yes we can use.it won't through any error and mappling is
also valid and also seccion also runnes secc-fully
.............
so what means u can use it
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / yugan
no.it won't support oracle keywords.infact it wil throw an
error.
| Is This Answer Correct ? | 1 Yes | 8 No |
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?
How you know when to use a static cache and dynamic cache in lookup transformation?
what is the difference between stop and abort
Is there any target staging area in informatica not staging area
What is synonym?
What is partioning?how many types of partinings are there
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to elaborate powercenter integration service?
What are the different options used to configure the sequential batches?
complex mapping ur project u r invlve can u explain and give real time example give me ?
can we override a native sql query within informatica? How do we do it?
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
Teradata 
