replace multiple spaces with single space.
Answers were Sorted based on User's Feedback
Answer / pushpendra
replacechr function can use.
replacechr(0,Column_Name,' ','')
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / xx
Its always better to use reg_replace check the below link
https://etltechsolutions.wordpress.com/category/informatica/
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / kartik
Hops I ound Trip Time robe1
to
Hops I ound Trip Time robe1
Is This Answer Correct ? | 0 Yes | 1 No |
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
How to update a particular record in target with out running whole workflow?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...
How big was your fact table
What differs when we choose the sorted input for aggregator transformation?
What did you do in source pre load stored procedure
What are the tuning techniques you applied during your last project
How to list Top 10 salary, without using Rank Transmission?
how to connect two or more table with single source qualifier?
Can you generate sequence numbers without using the sequence generator transformation?