Interested to Buy Any Domain ? << Click Here >> for more details...
I have a text file name x
With a text message. Word informatica
Is repeated for n number of times.
How to count the number of occurrence
Of word informatica
Of word informatic in this file x.
- 1 Answers
- 3613 Views
- Wipro, I also Faced
- E-Mail Answers
After SQ take exp trans
exp :
V_COUNT=V_COUNT+1
O_COUNT=V_COUNT
Aggr trans :
COUNT(O_COUNT)
| Is This Answer Correct ? | 0 Yes | 2 No |
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
What is standalone command task?
hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.
Is snow flake or star schema used? If star schema means why?
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
How is Data Models Used in Practice?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
How will u find weather dimension table is big in size of a fact table?
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
Teradata 
