without using emailtask how will send a mail from informatica?
Answers were Sorted based on User's Feedback
Answer / swathi
by using 'mailx' command in unix of shell scripting
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / trin
mailx in command task
for example:cat file.out |mailx -s 'Subject'
rrf@example.com
Is This Answer Correct ? | 0 Yes | 1 No |
What is target designer and target load order?
what is the need of session partitioning... how it is useful in real time
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
What is the Hierarchy of DWH?
how we load the data from source to staging area
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
When to use normalization transformation other than cobol source?
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
How we will implement Pushdown Optimization and Types in Informatica with better examples
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records