top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

String contains an untransable character?

0 votes
303 views

I have designed a mapping where i have flat file as source and teradata as target. I am using MS Windows Latin 1(super set of latin 1) code page.

Can anyone help me to find it out?

posted Jul 1, 2014 by Sachin

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button
Need some more information about where this issue is causing you pain. There are ways to work around it but your question is too vague to offer advice. Can you provide more details?
commented Jul 9, 2014 by Shweta Singh

Similar Questions
+1 vote
microsoft odbc driver manager the specified dsn contains an architecture miss match between driver and application

in my case, i have an expression transformation which uses the default function ERROR('transformation') to skip the records in which date value coming inside is not in the correct format. In this, the skipped rows are not written to the reject files, so that we are getting the reconcilation problem. I need the skipped rows to be written to the bad files.Please help me how can i achieve this.

+5 votes
Facing an issue while writing program for duplicate occurrence of a character in a string, can any one help? 
#include<stdio.h>
#include<string.h>
main()
{
    char p[100];
    int i,len;
    printf("Enter a string\n");
    scanf("%[^\n]",p);
    len=strlen(p);
    for(i=0;i<len-1;i++)
    {
        if(a[i]==a[i+1])
              p[i]=p[i+1];
    }
    printf("String :  %s\n",p);
}
+1 vote
Informatica character sequence

I am trying to create character sequence like AAA, AAB, AAC, AAD,....,BAA, BAB, BAC,.... and So on in a flat file using Informatica. I have the formula to create the charater sequence.

Here I need to have sequence numbers generated in informatica. But I dont have any source file or database to have this source.

Is there any method in Informatica to create sequence using Sequence Generater when there is no source records to read?

+1 vote
CMD file has 256 character length limit

I am generating a .CMD file using Informatica 9.5. It creates two MOVE commands (in the same file, 2 separate lines) with paths being picked from parameter files. The total length of the MOVE command exceeds 256 characters, and when the .CMD file is generated, it truncates this path when it reaches that character limit.

How do I resolve this issue?

The expression I am using in Informatica transformation is:

'MOVE "'  ||  $$FROM_PATH1  || 'FOO.ZIP"  "'  || $$TO_PATH  ||   'FOO' ||  '.ZIP"'  || CHR(10)      ||  
'MOVE "'  ||  $$FROM_PATH2  || 'BAR.ZIP"  "'  || $$TO_PATH  ||   'BAR'  ||  '.ZIP"'

When the CMD file is generated, it truncates the second variable and looks something like this:

MOVE "\\ABC\XYZ\FOLDER1\FOO.ZIP" "\\ABC\XYZ\FOLFOO.ZIP"
MOVE "\\ABC\XYZ\FOLDER2\BAR.ZIP" "\\ABC\XYZ\FOLBAR.ZIP"

Assuming that $$TO_PATH was \ABC\XYZ\FOLDER3\, notice that it has truncated the variable path but has still added the hard-coded characters. What gives?

...