Interested to Buy Any Domain ? << Click Here >> for more details...
i hav a scenario like this i want load data from source to
target as follows frist it counts the num of deptno and
display with that with count and how many times it reapts
along with all the records in source
- 1 Answers
- 4193 Views
- I also Faced
- E-Mail Answers
Answer / santha
for this scenario You can use the ANALYTIC function.It give
all the total count and individual count...
| Is This Answer Correct ? | 2 Yes | 0 No |
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is the Difference between sorter and aggregator?
What are the different components of powercenter?
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
What is difference between partioning of relatonal target and partitioning of file targets?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
What is dimensional table?
How can we eliminate duplicate rows from flatfile,explain?
explan ur project architecture?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Filter transformation in the condition one of the data is NULL would the record be dropped.
Teradata 
